var result = { "success": true, "data": { "plan": { "id": "P002", "name": "2022经销商折扣政策A", "statecode": "Input", "buckets": [ { "code": "record-list-Bucket", "name": "协议与政策", "children": [ { "code": "agreementList", "name": "协议备案", "dimension": "Tag", "size": 20, "columncount": 17, "children": [ { "id": "record-03", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[协议备案].[备案类型]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false }, { "id": "record-04", "bandid": "record_list", "code": "category_name", "name": "折扣类型", "fieldname": "category_name", "expression": "[协议备案].[折扣类型]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-05", "bandid": "record_list", "code": "doc_date", "name": "备案日期", "fieldname": "doc_date", "expression": "[协议备案].[备案日期]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-06", "bandid": "record_list", "code": "active_date", "name": "生效日期", "fieldname": "active_date", "expression": "[协议备案].[生效日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-07", "bandid": "record_list", "code": "dealer_code", "name": "经销商编码", "fieldname": "dealer_code", "expression": "[协议备案].[经销商编码]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-08", "bandid": "record_list", "code": "dealer_name", "name": "经销商名称", "fieldname": "dealer_name", "expression": "[协议备案].[经销商名称]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-09", "bandid": "record_list", "code": "customer_province", "name": "终端省份", "fieldname": "customer_province", "expression": "[协议备案].[终端省份]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-10", "bandid": "record_list", "code": "customer_city", "name": "终端城市", "fieldname": "customer_city", "expression": "[协议备案].[终端城市]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-11", "bandid": "record_list", "code": "customer_type", "name": "终端类型", "fieldname": "customer_type", "expression": "[协议备案].[终端类型]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-12", "bandid": "record_list", "code": "customer_code", "name": "终端编码", "fieldname": "customer_code", "expression": "[协议备案].[终端编码]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-13", "bandid": "record_list", "code": "customer_name", "name": "终端名称", "fieldname": "customer_name", "expression": "[协议备案].[终端名称]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-14", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[协议备案].[产品编码]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-15", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[协议备案].[产品名称]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-16", "bandid": "record_list", "code": "price_flow", "name": "流向价格", "fieldname": "price_flow", "expression": "[协议备案].[流向价格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-17", "bandid": "record_list", "code": "price_rebate", "name": "折扣单价", "fieldname": "price_rebate", "expression": "[协议备案].[折扣单价]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "record-18", "bandid": "record_list", "code": "joint_id", "name": "join_id", "fieldname": "joint_id", "expression": "[协议备案].[join_id]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false }, { "id": "record-19", "bandid": "record_list", "code": "source_name", "name": "source_name", "fieldname": "source_name", "expression": "[协议备案].[source_name]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false } ] } ] }, { "code": "flow-list-Bucket", "name": "业务数据", "children": [ { "code": "factorysale", "name": "工厂发货", "dimension": "Tag", "size": 120, "columncount": 13, "children": [ { "id": "flow-factory-01", "bandid": "flow_factory", "code": "year", "name": "年份", "fieldname": "year", "expression": "[工厂发货].[年份]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-02", "bandid": "flow_factory", "code": "month", "name": "月份", "fieldname": "month", "expression": "[工厂发货].[月份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-03", "bandid": "flow_factory", "code": "doc_date", "name": "发货日期", "fieldname": "doc_date", "expression": "[工厂发货].[发货日期]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-04", "bandid": "flow_factory", "code": "doc_code", "name": "发货单号", "fieldname": "doc_code", "expression": "[工厂发货].[发货单号]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-05", "bandid": "flow_factory", "code": "customer_code", "name": "客户编码", "fieldname": "customer_code", "expression": "[工厂发货].[客户编码]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-06", "bandid": "flow_factory", "code": "customer_name", "name": "客户名称", "fieldname": "customer_name", "expression": "[工厂发货].[客户名称]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-07", "bandid": "flow_factory", "code": "province", "name": "客户省份", "fieldname": "province", "expression": "[工厂发货].[客户省份]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-08", "bandid": "flow_factory", "code": "city", "name": "客户城市", "fieldname": "city", "expression": "[工厂发货].[客户城市]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-09", "bandid": "flow_factory", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[工厂发货].[产品编码]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-10", "bandid": "flow_factory", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[工厂发货].[产品名称]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-11", "bandid": "flow_factory", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[工厂发货].[数量]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-12", "bandid": "flow_factory", "code": "price", "name": "单价", "fieldname": "price", "expression": "[工厂发货].[单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-factory-13", "bandid": "flow_factory", "code": "amt", "name": "金额", "fieldname": "amt", "expression": "[工厂发货].[金额]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false } ] }, { "code": "receiveList", "name": "回笼核销", "dimension": "Tag", "size": 120, "columncount": 9, "children": [ { "id": "receipt-01", "bandid": "receipt_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[回笼核销].[经销商编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-02", "bandid": "receipt_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[回笼核销].[经销商名称]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-03", "bandid": "receipt_list", "code": "doc_no", "name": "发货单号", "fieldname": "doc_no", "expression": "[回笼核销].[发货单号]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-04", "bandid": "receipt_list", "code": "delivery_date", "name": "发货日期", "fieldname": "delivery_date", "expression": "[回笼核销].[发货日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-05", "bandid": "receipt_list", "code": "receipt_date", "name": "回款日期", "fieldname": "receipt_date", "expression": "[回笼核销].[回款日期]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-06", "bandid": "receipt_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[回笼核销].[产品编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-07", "bandid": "receipt_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[回笼核销].[产品名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-09", "bandid": "receipt_list", "code": "qty", "name": "回款数量", "fieldname": "qty", "expression": "[回笼核销].[回款数量]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "receipt-08", "bandid": "receipt_list", "code": "amt", "name": "回款金额", "fieldname": "amt", "expression": "[回笼核销].[回款金额]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false } ] }, { "code": "terminalsale", "name": "终端纯销", "dimension": "Tag", "size": 120, "columncount": 17, "children": [ { "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[终端纯销].[年份]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[终端纯销].[月份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[终端纯销].[流向日期]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_code", "name": "业务单号", "fieldname": "doc_code", "expression": "[终端纯销].[业务单号]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[终端纯销].[上游编码]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[终端纯销].[上游名称]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省", "fieldname": "supplyer_province", "expression": "[终端纯销].[上游省]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游市", "fieldname": "supplyer_city", "expression": "[终端纯销].[上游市]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_code", "name": "客户编码", "fieldname": "customer_code", "expression": "[终端纯销].[客户编码]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_name", "name": "客户名称", "fieldname": "customer_name", "expression": "[终端纯销].[客户名称]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_province", "name": "客户省份", "fieldname": "customer_province", "expression": "[终端纯销].[客户省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_city", "name": "客户城市", "fieldname": "customer_city", "expression": "[终端纯销].[客户城市]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "单价", "fieldname": "price", "expression": "[终端纯销].[单价]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "flow-terminal-16", "bandid": "flow_terminal", "code": "amt", "name": "金额", "fieldname": "amt", "expression": "[终端纯销].[金额]", "indexno": 16, "ismeasure": false, "isshow": true, "isused": false, "fields": false } ] }, { "code": "ddiScore", "name": "经销商活跃度", "dimension": "Tag", "size": 10, "columncount": 7, "children": [ { "id": "ddi-score-01", "bandid": "ddi_score", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[经销商活跃度].[经销商编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-02", "bandid": "ddi_score", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[经销商活跃度].[经销商名称]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-03", "bandid": "ddi_score", "code": "is_ddi", "name": "是否直连", "fieldname": "is_ddi", "expression": "[经销商活跃度].[是否直连]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-04", "bandid": "ddi_score", "code": "is_providedata", "name": "按时提供数据", "fieldname": "is_providedata", "expression": "[经销商活跃度].[按时提供数据]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-05", "bandid": "ddi_score", "code": "is_balance", "name": "进销存平衡", "fieldname": "is_balance", "expression": "[经销商活跃度].[进销存平衡]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-06", "bandid": "ddi_score", "code": "score", "name": "总得分", "fieldname": "score", "expression": "[经销商活跃度].[总得分]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false }, { "id": "ddi-score-07", "bandid": "ddi_score", "code": "is_open", "name": "是否达标", "fieldname": "is_open", "expression": "[经销商活跃度].[是否达标]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false } ] } ] } ], "workbook": { "id": "rebate_test", "planid": "P002", "code": "rebate_test", "bandid": "record_list", "typecode": "main", "no": 2, "columns": [ { "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "折扣类型", "bandid": "agreementList", "bandcolumn": "category_name", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[协议备案].[折扣类型]", "orderno": 0, "align": "left", "formatter": "text", "width": "2.5" }, { "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "生效日期", "bandid": "agreementList", "bandcolumn": "active_date", "bookfield": "xtek60eyng85", "variant": "", "expression": "[协议备案].[生效日期]", "orderno": 1, "align": "center", "formatter": "text", "width": "1" }, { "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "生效日期", "bandid": "agreementList", "bandcolumn": "active_date", "bookfield": "bqof64azwg09", "variant": "", "expression": "[协议备案].[生效日期]", "orderno": 2, "align": "center", "formatter": "text", "width": "1" }, { "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "折扣类型", "bandid": "agreementList", "bandcolumn": "category_name", "bookfield": "mph0hre275nu", "variant": "", "expression": "[协议备案].[折扣类型]", "orderno": 3, "align": "center", "formatter": "text", "width": "1" }, { "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "生效日期", "bandid": "agreementList", "bandcolumn": "active_date", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[协议备案].[生效日期]", "orderno": 4, "align": "center", "formatter": "text", "width": "1" }, { "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "终端省份", "bandid": "agreementList", "bandcolumn": "customer_province", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[协议备案].[终端省份]", "orderno": 5, "align": "center", "formatter": "text", "width": "1" }, { "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "折扣类型", "bandid": "agreementList", "bandcolumn": "category_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[协议备案].[折扣类型]", "orderno": 6, "align": "center", "formatter": "text", "width": "1" }, { "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "备案日期", "bandid": "agreementList", "bandcolumn": "doc_date", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[协议备案].[备案日期]", "orderno": 7, "align": "center", "formatter": "text", "width": "1" }, { "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "生效日期", "bandid": "agreementList", "bandcolumn": "active_date", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[协议备案].[生效日期]", "orderno": 8, "align": "center", "formatter": "text", "width": "1" }, { "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "年份", "bandid": "factorysale", "bandcolumn": "year", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[工厂发货].[年份]", "orderno": 9, "align": "center", "formatter": "text", "width": "1" }, { "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "折扣类型", "bandid": "agreementList", "bandcolumn": "category_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[协议备案].[折扣类型]", "orderno": 10, "align": "center", "formatter": "text", "width": "1" }, { "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "折扣类型", "bandid": "agreementList", "bandcolumn": "category_name", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "[协议备案].[折扣类型]", "orderno": 11, "align": "center", "formatter": "text", "width": "1" }, { "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "dealer_code", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[协议备案].[经销商编码]", "orderno": 12, "align": "center", "formatter": "text", "width": "1" }, { "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "生效日期", "bandid": "agreementList", "bandcolumn": "active_date", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[协议备案].[生效日期]", "orderno": 13, "align": "center", "formatter": "text", "width": "1" }, { "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "终端类型", "bandid": "agreementList", "bandcolumn": "customer_type", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[协议备案].[终端类型]", "orderno": 14, "align": "center", "formatter": "text", "width": "1" }, { "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "dealer_code", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[协议备案].[经销商编码]", "orderno": 15, "align": "center", "formatter": "text", "width": "1" }, { "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "终端城市", "bandid": "agreementList", "bandcolumn": "customer_city", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[协议备案].[终端城市]", "orderno": 16, "align": "center", "formatter": "text", "width": "1" }, { "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "dealer_code", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "[协议备案].[经销商编码]", "orderno": 17, "align": "center", "formatter": "text", "width": "1" }, { "id": "73c480cab46d4599ab69cf8fe78c763f", "iskey": false, "indexno": 18, "code": "vmo73tkjgso7", "name": "备案日期", "bandid": "agreementList", "bandcolumn": "doc_date", "bookfield": "vmo73tkjgso7", "variant": "", "expression": "[协议备案].[备案日期]", "orderno": 18, "align": "center", "formatter": "text", "width": "1" }, { "id": "1285a65b8b78487295b755e519fb3d39", "iskey": false, "indexno": 19, "code": "zyusyivo61at", "name": "产品名称", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "zyusyivo61at", "variant": "", "expression": "[协议备案].[产品名称]", "orderno": 19, "align": "center", "formatter": "text", "width": "1" }, { "id": "5a983ff5548949dbb4a7a6adf336acf0", "iskey": false, "indexno": 20, "code": "o2i6fvtgz0fc", "name": "备案日期", "bandid": "agreementList", "bandcolumn": "doc_date", "bookfield": "o2i6fvtgz0fc", "variant": "", "expression": "[协议备案].[备案日期]", "orderno": 20, "align": "center", "formatter": "text", "width": "1" }, { "id": "eb92361b02db4f90b3cf2d4fd2a20df4", "iskey": false, "indexno": 21, "code": "zhjhvvqyzmsf", "name": "月份", "bandid": "factorysale", "bandcolumn": "month", "bookfield": "zhjhvvqyzmsf", "variant": "", "expression": "[工厂发货].[月份]", "orderno": 21, "align": "center", "formatter": "text", "width": "1" }, { "id": "fdf89b3ed2ee458f8c178689c2f9bed9", "iskey": false, "indexno": 22, "code": "ngi6876mfsmq", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "dealer_code", "bookfield": "ngi6876mfsmq", "variant": "", "expression": "[协议备案].[经销商编码]", "orderno": 22, "align": "center", "formatter": "text", "width": "1" }, { "id": "ce380e8a76a2437fb184bb97abbe5646", "iskey": false, "indexno": 23, "code": "pjmts7wbej96", "name": "折扣单价", "bandid": "agreementList", "bandcolumn": "price_rebate", "bookfield": "pjmts7wbej96", "variant": "", "expression": "[协议备案].[折扣单价]", "orderno": 23, "align": "center", "formatter": "text", "width": "1" }, { "id": "93c84b3be2034c17aa5b2e2fa53c4f8c", "iskey": false, "indexno": 24, "code": "e63jbyr31snv", "name": "数量", "bandid": "terminalsale", "bandcolumn": "qty", "bookfield": "e63jbyr31snv", "variant": "", "expression": "[终端纯销].[数量]", "orderno": 24, "align": "center", "formatter": "text", "width": "1" }, { "id": "vblapsbj5q5rrzphascq", "iskey": false, "indexno": 25, "code": "b98a71fwca0v", "name": "折扣金额", "bandid": "", "bandcolumn": "", "bookfield": "b98a71fwca0v", "variant": "pjmts7wbej96, e63jbyr31snv", "expression": "[折扣单价]×[数量]", "orderno": 25, "align": "right", "formatter": "money", "width": "1" } ] } } } } var result_2 = { "success": true, "data": { "datalist": { "m8t1j589zoxx": [ "折扣-省标", "折扣-二次议价", "折扣-经销商合规", "折扣-省标", "折扣-省标", "折扣-二次议价", "二次议价补差", "二次议价补差", "军标补差协议", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "二次议价补差", "商业规范操作折让" ], "xtek60eyng85": [ "2024-06-30", "2022-12-31", "2022-12-31", "2022-10-28", "2022-10-28", "2022-12-31", "2022-03-31", "2022-06-30", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31" ], "bqof64azwg09": [ "2024-06-30", "2022-12-31", "2022-12-31", "2022-10-28", "2022-10-28", "2022-12-31", "2022-03-31", "2022-06-30", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31" ], "mph0hre275nu": [ "折扣-省标", "折扣-二次议价", "折扣-经销商合规", "折扣-省标", "折扣-省标", "折扣-二次议价", "二次议价补差", "二次议价补差", "军标补差协议", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "二次议价补差", "商业规范操作折让" ], "tfkcx7ku08ld": [ "2024-06-30", "2022-12-31", "2022-12-31", "2022-10-28", "2022-10-28", "2022-12-31", "2022-03-31", "2022-06-30", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31" ], "v13kggpbbpco": [ "上海市", "内蒙古自治区", null, "湖北省", "湖北省", "吉林省", "上海市", "上海市", "吉林省", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "云南省" ], "bdlzd0nfpsm1": [ "折扣-省标", "折扣-二次议价", "折扣-经销商合规", "折扣-省标", "折扣-省标", "折扣-二次议价", "二次议价补差", "二次议价补差", "军标补差协议", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "二次议价补差", "商业规范操作折让" ], "g0r05cr2x7kl": [ "2022-06-01", "2022-01-01", "2022-10-03", "2022-10-05", "2022-10-05", "2022-08-01", "2022-01-01", "2022-04-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-07-01", "2022-01-01" ], "j57u8la2edbu": [ "2024-06-30", "2022-12-31", "2022-12-31", "2022-10-28", "2022-10-28", "2022-12-31", "2022-03-31", "2022-06-30", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31" ], "qqxrwkpniqdd": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "dqcmdpzpt2oz": [ "折扣-省标", "折扣-二次议价", "折扣-经销商合规", "折扣-省标", "折扣-省标", "折扣-二次议价", "二次议价补差", "二次议价补差", "军标补差协议", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "二次议价补差", "商业规范操作折让" ], "tkdrha0j5z4a": [ "折扣-省标", "折扣-二次议价", "折扣-经销商合规", "折扣-省标", "折扣-省标", "折扣-二次议价", "二次议价补差", "二次议价补差", "军标补差协议", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "回笼履约折让", "二次议价补差", "商业规范操作折让" ], "cv6doar7tb0n": [ "CH00002", "CH00037", "CH00030", "CH00006", "CH00006", "CH00030", "CH00002", "CH00002", "CH00001", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00001" ], "g0ckvxzpde1w": [ "2024-06-30", "2022-12-31", "2022-12-31", "2022-10-28", "2022-10-28", "2022-12-31", "2022-03-31", "2022-06-30", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31", "2022-12-31" ], "io8cdw34jkvx": [ null, "医院", null, null, null, "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院", "医院" ], "gthzjxbrz9fp": [ "CH00002", "CH00037", "CH00030", "CH00006", "CH00006", "CH00030", "CH00002", "CH00002", "CH00001", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00001" ], "duoeeegbmf29": [ null, "呼和浩特市", null, null, null, "长春市", "上海市", "上海市", "长春市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "上海市", "昆明市" ], "pcuki55dq5i2": [ "CH00002", "CH00037", "CH00030", "CH00006", "CH00006", "CH00030", "CH00002", "CH00002", "CH00001", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00001" ], "vmo73tkjgso7": [ "2022-06-01", "2022-01-01", "2022-10-03", "2022-10-05", "2022-10-05", "2022-08-01", "2022-01-01", "2022-04-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-07-01", "2022-01-01" ], "zyusyivo61at": [ "板蓝根颗粒（100g*12）", "感冒灵颗粒（50g*6）", null, "银杏叶软胶囊|20|18粒/瓶_200瓶/箱", "银杏叶软胶囊|20|18粒/瓶_200瓶/箱", "感冒灵颗粒（50g*12）", "康莱软胶囊|每粒装0.45g|36粒/瓶*50瓶/箱", "康莱软胶囊|每粒装0.45g|36粒/瓶*50瓶/箱", "康莱软胶囊|每粒装0.45g|36粒/瓶*50瓶/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱注射液|100ml：10g|1瓶/盒_21盒/箱", "康莱软胶囊|每粒装0.45g|36粒/瓶*50瓶/箱", "康莱软胶囊|每粒装0.45g|36粒/瓶*50瓶/箱" ], "o2i6fvtgz0fc": [ "2022-06-01", "2022-01-01", "2022-10-03", "2022-10-05", "2022-10-05", "2022-08-01", "2022-01-01", "2022-04-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-01-01", "2022-07-01", "2022-01-01" ], "zhjhvvqyzmsf": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "ngi6876mfsmq": [ "CH00002", "CH00037", "CH00030", "CH00006", "CH00006", "CH00030", "CH00002", "CH00002", "CH00001", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00002", "CH00001" ], "pjmts7wbej96": [ "5.00", "0.50", "100.00", "2.50", "2.50", "1.00", "0.50", "1.50", "3.70", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "0.50", "2.50", "5000.00" ], "e63jbyr31snv": [ "1.0", "68.0", null, "17.0", "85.0", "50.0", "8.0", "29.0", "62.0", null, null, null, null, null, null, null, null, null, null, null, null, "11.0", null ], "b98a71fwca0v": [ "5.0", "34.0", "0.0", "42.5", "212.5", "50.0", "4.0", "43.5", "229.4", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "27.5", "0.0" ] }, "type": "workbook" } }